package com.itheima.mapper;

import com.itheima.pojo.Article;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ArticleMapper {

    //新增
    @Insert("insert into article " +
            "(title,content,cover_img,state,category_id," +
            "create_user,create_time,update_time)" +
            " values(#{title},#{content},#{coverImg}," +
            "#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})")
    public void add(Article article) ;

    
    List<Article> list(Integer userid, Integer categoryId, String state);

    //根据id查询
    @Select("select * from article where id=#{id};")
    Article findById(Integer id);

    //根据id删除
    @Delete("delete from article where id=#{id}")
    void delete(Integer id);

    //更新文章
    @Update("update article set title=#{title}," +
            "content=#{content},cover_img=#{coverImg},state=#{state}," +
            "category_id=#{categoryId},update_time=#{updateTime}" +
            "where id=#{id}")
    void update(Article article);
}
